﻿
using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.SqlClient;
using System.Collections;
using Model;


namespace MsDAL
{
    public partial class Bas1a13DAL : Bas1a13Base
    {
        /// <summary>
        /// 修改
        /// </summary>
        /// <returns></returns>
        public SqlApp UpdateDtl(string pid, string spno, string listid)
        {
            Sys0a60DAL dal = new Sys0a60DAL();

            string sql = @" UPDATE Bas1a13 SET pid=@pid, spno=@spno WHERE listid = @listid ";

            SqlParameter[] parameters = {
				new SqlParameter("@pid",SqlDbType.NVarChar),
                new SqlParameter("@spno",SqlDbType.NVarChar),
                new SqlParameter("@listid",SqlDbType.NVarChar)
				};

            parameters[0].Value = pid;
            parameters[1].Value = spno;
            parameters[2].Value = listid;

            return new SqlApp(sql, new ArrayList(parameters), false, "更新销售商供应表失败！");
        }
    }
}
